package com.liu.project.dao;

import com.liu.project.pojo.Personality;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @program: project
 * @description: 性格 职业类
 * @author: 86187
 * @create: 2022-04-20 16:53
 **/

@Mapper
@Repository
public interface PersonalityCommMapper {

    //获取所有的性格类型
    List<Personality> getAll();

    //根据名字查询id
    int getIdByPName(String perName);



    //根据personality中的id 到person_prof 的mbid查询职业表的pfvalue 联表查询
    List<Double> getPfvalueByMbid(int mbid);
}
